<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10" viewPagesAsTabs="topLeft"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Host Info"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Physical Assets - Host Info </staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows><conditionalRender refVariable="ShowHeader"><renderFor refVariableValue="1"/></conditionalRender></table><list horizontalPagination="true" name="List1" refQuery="Host Info" rowsPerPage="5000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Host Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Host Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Model"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Model"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Vendor"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Vendor"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="IPs"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="IPs"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="OS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="OS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="CPU Count"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="CPU Count"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="CPU Speed"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="CPU Speed"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Memory GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Memory GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="HBA Ports"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="HBA Ports"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="HBA Speed"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="HBA Speed"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="HBA F/W"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="HBA F/W"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Data Center"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Data Center"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						<page name="GuestOS">
			<pageBody>
				<contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Physical Assets - Guest OS</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows><conditionalRender refVariable="ShowHeader"><renderFor refVariableValue="1"/></conditionalRender></table><list horizontalPagination="true" name="List2" refQuery="GuestOS" rowsPerPage="5000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="IP"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;width:125px;word-wrap:break-word;word-break:break-all"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Trunc_IP"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Host Names"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Host Names"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="V-Cluster"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="V-Cluster"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="OS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="OS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Processors"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Processors"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="VM Memory (MB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="VM Memory (MB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Node"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Node"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Resource Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Resource Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Resource Technology"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Resource Technology"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Datastore"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Datastore"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used Capacity (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Used Capacity (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Resource Used Capacity (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Resource Used Capacity (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Power State"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Power State"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="pb"/>
					</defaultStyles>
				</style>
			</pageBody>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="pg"/>
				</defaultStyles>
			<CSS value="width:30in"/></style>
		</page><page name="FC Switches">
			<pageBody>
				<contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Physical Assets - FC Switches</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows><conditionalRender refVariable="ShowHeader"><renderFor refVariableValue="1"/></conditionalRender></table><list horizontalPagination="true" name="List3" refQuery="Switch Fabric">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Switch Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Switch Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="IP"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="IP"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Vendor"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Vendor"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Model"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Model"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Firmware"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Firmware"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Serial Number"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Serial Number"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Ports"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Ports"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used Ports"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat whenMissing="0" whenZero="0" whenDivideZero="0" whenNumericOverflow="0" whenNotApplicable="0" whenAnyError="0" whenSecurityError="0"/></dataFormat><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Used Ports"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Free Ports"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat whenMissing="0" whenZero="0" whenDivideZero="0" whenNumericOverflow="0" whenNotApplicable="0" whenAnyError="0" whenSecurityError="0"/></dataFormat><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Free Ports"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Status"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Status"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Type"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Type"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Data Center"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Data Center"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="pb"/>
					</defaultStyles>
				</style>
			</pageBody>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="pg"/>
				</defaultStyles>
			</style>
		</page><page name="Switch Connectivity">
			<pageBody>
				<contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Physical Assets - Switch Connectivity</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows><conditionalRender refVariable="ShowHeader"><renderFor refVariableValue="1"/></conditionalRender></table><list horizontalPagination="true" name="List4" refQuery="Switch Connectivity" rowsPerPage="5000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Physical Switch"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Physical Switch"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Physical Port Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Physical Port Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Physical Port WWN"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Physical Port WWN"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Virtual Switch"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Virtual Switch"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Virtual Port Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Virtual Port Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Virtual Port WWN"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Virtual Port WWN"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Port Type"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Port Type"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Port Speed"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Port Speed"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Blade"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Blade"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Status"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Status"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Status Detail"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Status Detail"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Connected WWN"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Connected WWN"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Device Type"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Device Type"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Physical Device"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Physical Device"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Virtual Device"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Virtual Device"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="pb"/>
					</defaultStyles>
				</style>
			</pageBody>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="pg"/>
				</defaultStyles>
			</style>
		</page><page name="Storage Arrays">
			<pageBody>
				<contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Physical Assets - Storage Arrays</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows><conditionalRender refVariable="ShowHeader"><renderFor refVariableValue="1"/></conditionalRender></table><list horizontalPagination="true" name="List5" refQuery="Storage Arrays" rowsPerPage="5000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Vendor"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Vendor"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Family"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Family"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Microcode Version"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Microcode Version"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="IP"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="IP"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Node Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Node Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Model"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Model"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Serial Number"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Serial Number"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="State"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="State"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Raw (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Raw (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Capacity (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Capacity (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Protocol"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:center"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Protocol"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Data Center"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Data Center"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="pb"/>
					</defaultStyles>
				</style>
			</pageBody>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="pg"/>
				</defaultStyles>
			</style>
		</page></reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>7.12 Physical Assets</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="Host Info"><source><sqlQuery name="SQL1" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT DISTINCT
SUBSTR(dwh_inventory.host.name,1,LOCATE('.',dwh_inventory.host.name)-1) as 'Host Name',
dwh_inventory.host.id as 'Hostid',
dwh_inventory.host.model as 'Model',
dwh_inventory.host.manufacturer as 'Vendor',
dwh_inventory.host.ip as 'IPs',
dwh_inventory.host.os as 'OS',
CAST(dwh_inventory.host.cpuCount as char) as 'CPU Count',
CAST(dwh_inventory.host.cpuSpeed as char) as 'CPU Speed',
ROUND(dwh_inventory.host.installedMemoryMB/1024,0) as 'Memory GB',
COUNT(dwh_inventory.host_port.wwn) as 'HBA Ports',
dwh_inventory.host_port.speed as 'HBA Speed',
dwh_inventory.host_adapter.firmware as 'HBA F/W',
dwh_inventory.application.name as 'Application',
dwh_inventory.host.datacenter as 'Data Center'

FROM dwh_inventory.host
LEFT JOIN dwh_inventory.host_port
ON dwh_inventory.host.id=dwh_inventory.host_port.hostid
LEFT JOIN dwh_inventory.host_adapter
ON dwh_inventory.host.id=dwh_inventory.host_adapter.hostid
LEFT JOIN dwh_inventory.host_to_application
ON dwh_inventory.host.id=dwh_inventory.host_to_application.hostid
LEFT JOIN dwh_inventory.application
ON dwh_inventory.application.id=dwh_inventory.host_to_application.applicationid

GROUP BY dwh_inventory.host.id, dwh_inventory.host_adapter.hostid, dwh_inventory.host_port.wwn

ORDER BY dwh_inventory.host.os DESC
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Host Name"/><mdProjectedItem name="Hostid"/><mdProjectedItem name="Model"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="IPs"/><mdProjectedItem name="OS"/><mdProjectedItem name="CPU Count"/><mdProjectedItem name="CPU Speed"/><mdProjectedItem name="Memory GB"/><mdProjectedItem name="HBA Ports"/><mdProjectedItem name="HBA Speed"/><mdProjectedItem name="HBA F/W"/><mdProjectedItem name="Application"/><mdProjectedItem name="Data Center"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Host Name"><expression>[SQL1].[Host Name]</expression></dataItem><dataItem name="Hostid"><expression>[SQL1].[Hostid]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Vendor"><expression>[SQL1].[Vendor]</expression></dataItem><dataItem name="IPs"><expression>[SQL1].[IPs]</expression></dataItem><dataItem name="OS"><expression>[SQL1].[OS]</expression></dataItem><dataItem name="CPU Count"><expression>[SQL1].[CPU Count]</expression></dataItem><dataItem name="CPU Speed"><expression>[SQL1].[CPU Speed]</expression></dataItem><dataItem name="Memory GB"><expression>[SQL1].[Memory GB]</expression></dataItem><dataItem name="HBA Ports"><expression>[SQL1].[HBA Ports]</expression></dataItem><dataItem name="HBA Speed"><expression>[SQL1].[HBA Speed]</expression></dataItem><dataItem name="HBA F/W"><expression>[SQL1].[HBA F/W]</expression></dataItem><dataItem name="Application"><expression>[SQL1].[Application]</expression></dataItem><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem></selection></query><query name="GuestOS"><source><sqlQuery name="SQL2" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
X.Name as 'Name',
X.IP as 'IP',
X.HostNames as 'Host Names',
X.VCluster as 'V-Cluster',
X.OS as 'OS',
X.PowerState as 'Power State',
X.Processors as 'Processors',
X.VMMemoryMB as 'VM Memory (MB)',
X.UsedCapacityGB as 'Used Capacity (GB)',
X.Datastore as 'Datastore',
X.Application as 'Application',
IFNULL(Y.Storage,Z.Storage) as 'Storage',
IFNULL(Y.Node,Z.Node) as 'Node',
Y.ResourceName as 'Resource Name',
Y.ResourceUsedCapacityGB as 'Resource Used Capacity (GB)',
Y.ResourceTechnology as 'Resource Technology',
Z.Share as 'Share',
Z.Protocol as 'Protocol',
Z.NFSAllocatedGB as 'NFS Allocated (GB)',
Z.NFSVolume as 'NFS Volume',
Z.AllocatedGB as 'Allocated (GB)',
Z.NFSUsedGB as 'NFS Used GB'

FROM
(

SELECT DISTINCT
dwh_inventory.hv_virtual_machine.name as 'Name',
dwh_inventory.hv_virtual_machine.id as 'vmid',
dwh_inventory.hv_virtual_machine.ips as 'IP',
SUBSTR(dwh_inventory.host.name,1,LOCATE('.',dwh_inventory.host.name)-1) as 'HostNames',
dwh_inventory.hv_server.clustername as 'VCluster',
dwh_inventory.hv_virtual_machine.os as 'OS',
dwh_inventory.hv_virtual_machine.powerstate as 'PowerState',
dwh_inventory.hv_virtual_machine.processors as 'Processors',
dwh_inventory.hv_virtual_machine.memory as 'VMMemoryMB',
ROUND(dwh_inventory.hv_virtual_machine.usedCapacityMB/1024,2) as 'UsedCapacityGB',
dwh_inventory.hv_data_store.name as 'Datastore',
dwh_inventory.hv_data_store.id as 'datastoreid',
dwh_inventory.application.name as 'Application'


FROM dwh_inventory.hv_virtual_machine
JOIN dwh_inventory.vm_to_application
ON dwh_inventory.hv_virtual_machine.id=dwh_inventory.vm_to_application.vmid
JOIN dwh_inventory.application
ON dwh_inventory.application.id=dwh_inventory.vm_to_application.applicationid
JOIN dwh_inventory.host
ON dwh_inventory.host.id=dwh_inventory.hv_virtual_machine.hostid
JOIN dwh_inventory.hv_server
ON dwh_inventory.host.id=dwh_inventory.hv_server.hostid
JOIN dwh_inventory.hv_data_store
ON dwh_inventory.hv_data_store.id=dwh_inventory.hv_virtual_machine.datastoreid

WHERE SUBSTR(dwh_inventory.host.name,1,LOCATE('.',dwh_inventory.host.name)-1) NOT LIKE CONCAT('%','10','%')

GROUP BY dwh_inventory.hv_server.clustername, dwh_inventory.host.id, dwh_inventory.hv_virtual_machine.id, dwh_inventory.hv_data_store.id ) X


LEFT JOIN

(
SELECT DISTINCT
dwh_inventory.storage.name as 'Storage',
dwh_inventory.storage_node.name as 'Node',
SUBSTR(dwh_inventory.volume.name,LOCATE(':',dwh_inventory.volume.name)+1,100) as 'ResourceName',
ROUND(dwh_inventory.volume.consumedCapacityMB/1024,0) as 'ResourceUsedCapacityGB',
IF(dwh_inventory.volume.technologytype='FC','Fibre Channel',dwh_inventory.volume.technologytype) as 'ResourceTechnology',

dwh_inventory.hv_data_store.id as sdatastoreid

FROM dwh_inventory.hv_data_store
JOIN dwh_inventory.hv_data_store_to_volume
ON dwh_inventory.hv_data_store.id=dwh_inventory.hv_data_store_to_volume.datastoreid
JOIN dwh_inventory.volume
ON dwh_inventory.volume.id=dwh_inventory.hv_data_store_to_volume.volumeid
JOIN dwh_inventory.storage
ON dwh_inventory.storage.id=dwh_inventory.hv_data_store_to_volume.storageid
JOIN dwh_inventory.storage_node
ON dwh_inventory.storage.id=dwh_inventory.storage_node.storageid

GROUP BY dwh_inventory.hv_data_store.id


) Y ON Y.sdatastoreid=X.datastoreid


LEFT JOIN
(

SELECT DISTINCT
dwh_inventory.storage.name as 'Storage',
dwh_inventory.storage_node.name as 'Node',
dwh_inventory.hv_data_store.id as 'ndatastoreid',
dwh_inventory.hv_nas_share.sharePath as 'Share',
dwh_inventory.hv_nas_share.type as 'Protocol',
dwh_inventory.hv_nas_share.capacityMB/1024 as 'NFSAllocatedGB',
SUBSTR(dwh_inventory.internal_volume.name,LOCATE(':',dwh_inventory.internal_volume.name)+1,100) as 'NFSVolume',
dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024 as 'AllocatedGB',
dwh_inventory.internal_volume.totalUsedCapacityMB/1024 as 'NFSUsedGB'


FROM            dwh_inventory.hv_virtual_machine
JOIN            dwh_inventory.hv_virtual_machine_to_disk
ON              dwh_inventory.hv_virtual_machine_to_disk.virtualmachineid=dwh_inventory.hv_virtual_machine.id
JOIN            dwh_inventory.hv_virtual_disk
ON              dwh_inventory.hv_virtual_disk.id=dwh_inventory.hv_virtual_machine_to_disk.virtualdiskid
JOIN            dwh_inventory.hv_data_store
ON              dwh_inventory.hv_data_store.id=dwh_inventory.hv_virtual_machine.datastoreid
JOIN            dwh_inventory.hv_data_store_to_internal_volume
ON              dwh_inventory.hv_data_store.id=dwh_inventory.hv_data_store_to_internal_volume.datastoreid
JOIN            dwh_inventory.internal_volume
ON              dwh_inventory.internal_volume.id=dwh_inventory.hv_data_store_to_internal_volume.internalvolumeid
JOIN            dwh_inventory.hv_datastore_to_nas_share
ON              dwh_inventory.hv_datastore_to_nas_share.datastoreid=dwh_inventory.hv_data_store.id
JOIN            dwh_inventory.hv_nas_share
ON              dwh_inventory.hv_nas_share.id=dwh_inventory.hv_datastore_to_nas_share.nasshareid
JOIN            dwh_inventory.hv_nas_share_to_share
ON              dwh_inventory.hv_nas_share_to_share.nasshareid=dwh_inventory.hv_nas_share.id
JOIN            dwh_inventory.storage
ON              dwh_inventory.hv_nas_share_to_share.storageid=dwh_inventory.storage.id
JOIN           dwh_inventory.storage_node
ON 	dwh_inventory.storage.id=dwh_inventory.storage_node.storageid
LEFT JOIN       dwh_inventory.hv_host_to_nas_share
ON              dwh_inventory.hv_host_to_nas_share.nasshareid=dwh_inventory.hv_nas_share.id
LEFT JOIN       dwh_inventory.host
ON              dwh_inventory.host.id=dwh_inventory.hv_host_to_nas_share.hostid


GROUP BY dwh_inventory.hv_virtual_machine.id,
	dwh_inventory.hv_data_store.id,
	dwh_inventory.hv_virtual_disk.id,
	dwh_inventory.internal_volume.id,
	dwh_inventory.hv_nas_share.id
) Z ON Z.ndatastoreid=X.datastoreid





</sqlText>
		<mdProjectedItems><mdProjectedItem name="Name"/><mdProjectedItem name="IP"/><mdProjectedItem name="Host Names"/><mdProjectedItem name="V-Cluster"/><mdProjectedItem name="OS"/><mdProjectedItem name="Power State"/><mdProjectedItem name="Processors"/><mdProjectedItem name="VM Memory (MB)"/><mdProjectedItem name="Used Capacity (GB)"/><mdProjectedItem name="Datastore"/><mdProjectedItem name="Application"/><mdProjectedItem name="Storage"/><mdProjectedItem name="Node"/><mdProjectedItem name="Resource Name"/><mdProjectedItem name="Resource Used Capacity (GB)"/><mdProjectedItem name="Resource Technology"/><mdProjectedItem name="Share"/><mdProjectedItem name="Protocol"/><mdProjectedItem name="NFS Allocated (GB)"/><mdProjectedItem name="NFS Volume"/><mdProjectedItem name="Allocated (GB)"/><mdProjectedItem name="NFS Used GB"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Name"><expression>[SQL2].[Name]</expression></dataItem><dataItem name="IP"><expression>[SQL2].[IP]</expression></dataItem><dataItem name="Host Names"><expression>[SQL2].[Host Names]</expression></dataItem><dataItem name="V-Cluster"><expression>[SQL2].[V-Cluster]</expression></dataItem><dataItem name="OS"><expression>[SQL2].[OS]</expression></dataItem><dataItem name="Power State"><expression>[SQL2].[Power State]</expression></dataItem><dataItem name="Processors"><expression>[SQL2].[Processors]</expression></dataItem><dataItem name="VM Memory (MB)"><expression>[SQL2].[VM Memory (MB)]</expression></dataItem><dataItem name="Used Capacity (GB)"><expression>[SQL2].[Used Capacity (GB)]</expression></dataItem><dataItem name="Datastore"><expression>[SQL2].[Datastore]</expression></dataItem><dataItem name="Application"><expression>[SQL2].[Application]</expression></dataItem><dataItem name="Storage"><expression>[SQL2].[Storage]</expression></dataItem><dataItem name="Node"><expression>[SQL2].[Node]</expression></dataItem><dataItem name="Resource Name"><expression>IF([SQL2].[Resource Name] is null) THEN ([SQL2].[NFS Volume]) ELSE ([SQL2].[Resource Name])</expression></dataItem><dataItem name="Resource Used Capacity (GB)"><expression>IF([SQL2].[Resource Used Capacity (GB)] is null) THEN ([SQL2].[NFS Used GB]) ELSE ([SQL2].[Resource Used Capacity (GB)])</expression></dataItem><dataItem name="Resource Technology"><expression>IF([SQL2].[Resource Technology] is null) THEN ([SQL2].[Protocol]) ELSE ([SQL2].[Resource Technology])</expression></dataItem><dataItem name="Share"><expression>[SQL2].[Share]</expression></dataItem><dataItem name="Protocol"><expression>[SQL2].[Protocol]</expression></dataItem><dataItem name="NFS Used GB"><expression>[SQL2].[NFS Used GB]</expression></dataItem><dataItem name="NFS Volume"><expression>[SQL2].[NFS Volume]</expression></dataItem><dataItem name="Trunc_IP"><expression>substring([IP],1,position(',fe',[IP])-1)</expression></dataItem></selection></query><query name="Switch Fabric">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
*
FROM
(
SELECT
dwh_inventory.switch.name as 'Switch Name',
dwh_inventory.switch.id as 'switchid',
dwh_inventory.switch.ip as 'IP',
dwh_inventory.switch.manufacturer as 'Vendor',
dwh_inventory.switch.model as 'Model',
dwh_inventory.switch.firmware as 'Firmware',
dwh_inventory.switch.serialnumber as 'Serial Number',
IF(dwh_inventory.switch.active=1,'OK','INACTIVE') as 'Status',
dwh_inventory.switch.type as 'Type',
dwh_inventory.switch.datacenter as 'Data Center'

FROM dwh_inventory.switch

GROUP BY dwh_inventory.switch.id ) X

LEFT JOIN

(
SELECT
	dwh_inventory.switch.id as sid,
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'Total Ports'
FROM	dwh_inventory.switch_port 
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
-- AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND              dwh_inventory.switch.id=switchid

GROUP BY dwh_inventory.switch.id ) Y ON Y.sid=X.switchid

LEFT JOIN

(SELECT 	
	dwh_inventory.switch.id as 'usid',
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'Used Ports'
FROM	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
-- AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND	dwh_inventory.switch_port.id IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)

GROUP BY dwh_inventory.switch.id ) YY ON YY.usid=X.switchid

LEFT JOIN

(
SELECT 	
	dwh_inventory.switch.id as 'fsid',
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'Free Ports'
FROM	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
-- AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)

GROUP BY dwh_inventory.switch.id) YYY ON YYY.fsid=X.switchid



</sqlText>
		<mdProjectedItems><mdProjectedItem name="Switch Name"/><mdProjectedItem name="switchid"/><mdProjectedItem name="IP"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Model"/><mdProjectedItem name="Firmware"/><mdProjectedItem name="Serial Number"/><mdProjectedItem name="Status"/><mdProjectedItem name="Type"/><mdProjectedItem name="Data Center"/><mdProjectedItem name="sid"/><mdProjectedItem name="Total Ports"/><mdProjectedItem name="usid"/><mdProjectedItem name="Used Ports"/><mdProjectedItem name="fsid"/><mdProjectedItem name="Free Ports"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Switch Name"><expression>[SQL5].[Switch Name]</expression></dataItem><dataItem name="IP"><expression>[SQL5].[IP]</expression></dataItem><dataItem name="Vendor"><expression>[SQL5].[Vendor]</expression></dataItem><dataItem name="Model"><expression>[SQL5].[Model]</expression></dataItem><dataItem name="Firmware"><expression>[SQL5].[Firmware]</expression></dataItem><dataItem name="Serial Number"><expression>[SQL5].[Serial Number]</expression></dataItem><dataItem name="Status"><expression>[SQL5].[Status]</expression></dataItem><dataItem name="Type"><expression>[SQL5].[Type]</expression></dataItem><dataItem name="Data Center"><expression>[SQL5].[Data Center]</expression></dataItem><dataItem name="Total Ports"><expression>[SQL5].[Total Ports]</expression></dataItem><dataItem name="Used Ports"><expression>[SQL5].[Used Ports]</expression></dataItem><dataItem name="Free Ports"><expression>[SQL5].[Free Ports]</expression></dataItem></selection>
		</query><query name="Switch Connectivity">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL3">
			<sqlText>SELECT
prim.switch as 'Physical Switch',
IF(vir.virtualSwitchName is null, prim.portName, null) as 'Physical Port Name',
IF(vir.virtualSwitchName is null, prim.portWWN, null) as 'Physical Port WWN',

IF(vir.virtualSwitchName is null,
CASE
WHEN prim.deviceType='HOST_PORT' THEN host.hostName 
WHEN prim.deviceType='SWITCH_PORT' THEN switch.switchName
WHEN prim.deviceType='GENERIC_DEVICE_PORT' THEN generic.genericWWN
WHEN prim.deviceType='STORAGE_PORT' THEN array.storage
END, null) as 'Physical Device',

IF(vir.virtualSwitchName is not null,
CASE
WHEN prim.deviceType='HOST_PORT' THEN host.hostName 
WHEN prim.deviceType='SWITCH_PORT' THEN switch.switchName
WHEN prim.deviceType='GENERIC_DEVICE_PORT' THEN generic.genericWWN
WHEN prim.deviceType='STORAGE_PORT' THEN array.storage
END, null) as 'Virtual Device',


vir.virtualSwitchName as 'Virtual Switch',
IF(vir.virtualSwitchName is not null, prim.portName, null) as 'Virtual Port Name',
IF(vir.virtualSwitchName is not null, prim.portWWN, null) as 'Virtual Port WWN',

prim.portType as 'Port Type',
prim.portspeed as 'Port Speed',
CONCAT(prim.blade, '-', prim.bladeNumber) as 'Blade',
prim.status as 'Status',
prim.statusDetail as 'Status Detail',

prim.connectedWWN as 'Connected WWN',

CASE
WHEN prim.deviceType ='HOST_PORT' THEN host.hostOS
ELSE prim.deviceType
END as 'Device Type'


/*
CASE
WHEN prim.deviceType='HOST_PORT' THEN host.hostName 
WHEN prim.deviceType='SWITCH_PORT' THEN switch.switchName
WHEN prim.deviceType='GENERIC_DEVICE_PORT' THEN generic.genericWWN
WHEN prim.deviceType='STORAGE_PORT' THEN array.storage
END as 'Device'
*/

FROM
(
SELECT
dwh_inventory.switch.name as switch,
dwh_inventory.switch_port.name as portName,
dwh_inventory.switch_port.type as portType,
dwh_inventory.switch_port.speed as portspeed,
dwh_inventory.switch_port.wwn as portWWN,
CAST(dwh_inventory.switch_port.blade as character) as blade,
CAST(dwh_inventory.switch_port.number as character) as bladeNumber,
dwh_inventory.switch_port.status as status,
dwh_inventory.switch_port.rawPortStatus statusDetail,
dwh_inventory.port_connectivity.connectedWWN as connectedWWN,
dwh_inventory.port_connectivity.connectedType as deviceType,
dwh_inventory.port_connectivity.connectedId as connectedId


FROM            dwh_inventory.switch
JOIN            dwh_inventory.switch_port
ON              dwh_inventory.switch_port.switchid=dwh_inventory.switch.id
LEFT JOIN       dwh_inventory.port_connectivity
ON              dwh_inventory.port_connectivity.portid=dwh_inventory.switch_port.id

WHERE dwh_inventory.switch_port.status='OK'

GROUP BY dwh_inventory.switch_port.name ) prim

LEFT JOIN

(
SELECT
dwh_inventory.host.name as hostName,
IF(dwh_inventory.host.os is not null, 'ESX/Virtual Server', 'Physical Server') as hostOS,
dwh_inventory.port_connectivity.connectedId

FROM    dwh_inventory.host
JOIN    dwh_inventory.host_port
ON      dwh_inventory.host_port.hostid=dwh_inventory.host.id
JOIN    dwh_inventory.port_connectivity
ON        dwh_inventory.host_port.id=dwh_inventory.port_connectivity.connectedId

GROUP BY dwh_inventory.host.name, dwh_inventory.port_connectivity.connectedId ) host ON host.connectedId=prim.connectedId

LEFT JOIN

(
SELECT
dwh_inventory.switch.name as switchName,
dwh_inventory.port_connectivity.connectedId as connectedId,
dwh_inventory.switch.wwn as switchwwn


FROM            dwh_inventory.switch
JOIN            dwh_inventory.switch_port
ON              dwh_inventory.switch_port.switchid=dwh_inventory.switch.id
LEFT JOIN       dwh_inventory.port_connectivity
ON              dwh_inventory.port_connectivity.portid=dwh_inventory.switch_port.id

GROUP BY dwh_inventory.switch_port.name) switch ON switch.connectedId=prim.connectedId

LEFT JOIN
(
SELECT
dwh_inventory.generic_device_port.wwn as genericWWN,
dwh_inventory.generic_device_port.id as connectedId

FROM dwh_inventory.generic_device_port) generic ON generic.connectedId=prim.connectedId

LEFT JOIN
(
SELECT
dwh_inventory.storage.name as storage,
dwh_inventory.storage_port.id as connectedId

FROM    dwh_inventory.storage
JOIN    dwh_inventory.storage_port
ON      dwh_inventory.storage_port.storageid=dwh_inventory.storage.id
) array ON array.connectedId=prim.connectedId

LEFT JOIN
(
select
dwh_inventory.virtual_switch.wwn as virtualSwitchWWN,
dwh_inventory.virtual_switch.name as virtualSwitchName,
dwh_inventory.virtual_switch.chassisWwn as chassisWwn,
dwh_inventory.virtual_switch.ip as vSwitchIP,
dwh_inventory.fabric.name as fabric

FROM dwh_inventory.virtual_switch


JOIN    dwh_inventory.fabric
ON      dwh_inventory.fabric.id=dwh_inventory.virtual_switch.fabricid


) vir ON vir.chassisWwn=switch.switchwwn

GROUP BY prim.switch, vir.virtualSwitchName, prim.portName





</sqlText>
		<mdProjectedItems><mdProjectedItem name="Physical Switch"/><mdProjectedItem name="Physical Port Name"/><mdProjectedItem name="Physical Port WWN"/><mdProjectedItem name="Physical Device"/><mdProjectedItem name="Virtual Device"/><mdProjectedItem name="Virtual Switch"/><mdProjectedItem name="Virtual Port Name"/><mdProjectedItem name="Virtual Port WWN"/><mdProjectedItem name="Port Type"/><mdProjectedItem name="Port Speed"/><mdProjectedItem name="Blade"/><mdProjectedItem name="Status"/><mdProjectedItem name="Status Detail"/><mdProjectedItem name="Connected WWN"/><mdProjectedItem name="Device Type"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Physical Switch"><expression>[SQL3].[Physical Switch]</expression></dataItem><dataItem name="Physical Port Name"><expression>[SQL3].[Physical Port Name]</expression></dataItem><dataItem name="Physical Port WWN"><expression>[SQL3].[Physical Port WWN]</expression></dataItem><dataItem name="Virtual Switch"><expression>[SQL3].[Virtual Switch]</expression></dataItem><dataItem name="Virtual Port Name"><expression>[SQL3].[Virtual Port Name]</expression></dataItem><dataItem name="Virtual Port WWN"><expression>[SQL3].[Virtual Port WWN]</expression></dataItem><dataItem name="Port Type"><expression>[SQL3].[Port Type]</expression></dataItem><dataItem name="Port Speed"><expression>[SQL3].[Port Speed]</expression></dataItem><dataItem name="Blade"><expression>[SQL3].[Blade]</expression></dataItem><dataItem name="Status"><expression>[SQL3].[Status]</expression></dataItem><dataItem name="Status Detail"><expression>[SQL3].[Status Detail]</expression></dataItem><dataItem name="Connected WWN"><expression>[SQL3].[Connected WWN]</expression></dataItem><dataItem name="Device Type"><expression>[SQL3].[Device Type]</expression></dataItem><dataItem name="Physical Device"><expression>[SQL3].[Physical Device]</expression></dataItem><dataItem name="Virtual Device"><expression>[SQL3].[Virtual Device]</expression></dataItem><dataItem aggregate="total" name="Physical Port Count"><expression>Count([Physical Port Name])</expression></dataItem><dataItem aggregate="total" name="Virtual Port Count"><expression>count([Virtual Port Name])</expression></dataItem><dataItem name="Total Online Ports"><expression>count([Physical Port Name]) + count([Virtual Port Name])</expression></dataItem></selection>
		</query><query name="Storage Arrays">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
*
FROM
(

SELECT DISTINCT
dwh_inventory.storage.name as 'Storage Name',
dwh_inventory.storage.id as storageid,
dwh_inventory.storage.manufacturer as 'Vendor',
dwh_inventory.storage.family as 'Family',
dwh_inventory.storage.microcodeversion as 'Microcode Version',
dwh_inventory.storage.datacenter as 'Data Center',
dwh_inventory.storage.ip as 'IP',
dwh_inventory.storage_node.name as 'Node Name',
IF(dwh_inventory.storage_node.name is not null, dwh_inventory.storage_node.model, dwh_inventory.storage.model) as 'Model',
IF(dwh_inventory.storage_node.name is not null and dwh_inventory.storage_node.serialnumber&lt;&gt;'' , dwh_inventory.storage_node.serialnumber, dwh_inventory.storage.serialnumber) as 'Serial Number',
IF(dwh_inventory.storage_node.name is not null, dwh_inventory.storage_node.state, IF(dwh_inventory.storage.active=1, 'Active', 'InActive')) as 'State',
ROUND(dwh_inventory.storage.rawCapacityMB/1024/1024,2) as 'Raw (TB)',
ROUND(SUM(dwh_inventory.storage_pool.totalAllocatedCapacityMB)/1024/1024,2) as 'Capacity (TB)'


FROM dwh_inventory.storage
JOIN dwh_inventory.storage_node
ON dwh_inventory.storage.id=dwh_inventory.storage_node.storageid
JOIN dwh_inventory.storage_node_to_storage_pool
ON dwh_inventory.storage_node.id=dwh_inventory.storage_node_to_storage_pool.storagenodeid
JOIN dwh_inventory.storage_pool
ON dwh_inventory.storage_pool.id=dwh_inventory.storage_node_to_storage_pool.storagepoolid 
WHERE dwh_inventory.storage.manufacturer='netapp'

GROUP BY dwh_inventory.storage.id, dwh_inventory.storage_node.id 

UNION

SELECT DISTINCT
dwh_inventory.storage.name as 'Storage Name',
dwh_inventory.storage.id as storageid,
dwh_inventory.storage.manufacturer as 'Vendor',
dwh_inventory.storage.family as 'Family',
dwh_inventory.storage.microcodeversion as 'Microcode Version',
dwh_inventory.storage.datacenter as 'Data Center',
dwh_inventory.storage.ip as 'IP',
null as 'Node Name',
dwh_inventory.storage.model as 'Model',
dwh_inventory.storage.serialnumber as 'Serial Number',
IF(dwh_inventory.storage.active=1, 'Active', 'InActive') as 'State',
ROUND(dwh_inventory.storage.rawCapacityMB/1024/1024,2) as 'Raw (TB)',
ROUND(SUM(dwh_inventory.storage_pool.totalAllocatedCapacityMB)/1024/1024,2) as 'Capacity (TB)'

FROM dwh_inventory.storage
JOIN dwh_inventory.storage_pool
ON dwh_inventory.storage.id=dwh_inventory.storage_pool.storageid

WHERE dwh_inventory.storage.manufacturer&lt;&gt;'netapp'

GROUP BY dwh_inventory.storage.id

) X


LEFT JOIN


(
SELECT
A.storageid as pstorageid,
REPLACE(TRIM(CONCAT( IF(B.iSCSI&gt;0, 'iSCSI', ''),' ',IF(C.FC&gt;0, 'FC', ''),' ',IF(D.NFS&gt;0,'NFS',''),' ',IF(E.CIFS&gt;0,'CIFS',''))),' ',', ') as 'Protocol'

FROM
(

SELECT
dwh_inventory.storage.id as storageid


FROM dwh_inventory.storage 
GROUP BY dwh_inventory.storage.id

) A

LEFT JOIN

(
SELECT DISTINCT
dwh_inventory.storage.id as bsid,
COUNT(*) as 'iSCSI'

FROM dwh_inventory.storage
JOIN dwh_inventory.iscsi_logical
ON dwh_inventory.storage.id=dwh_inventory.iscsi_logical.storageid
GROUP BY dwh_inventory.storage.id ) B ON B.bsid=A.storageid

LEFT JOIN

(
SELECT DISTINCT
dwh_inventory.storage.id as csid,
COUNT(*) as 'FC'

FROM dwh_inventory.storage
JOIN dwh_inventory.volume_map
ON dwh_inventory.storage.id=dwh_inventory.volume_map.storageid
GROUP BY dwh_inventory.storage.id ) C ON C.csid=A.storageid

LEFT JOIN

(
SELECT DISTINCT
dwh_inventory.storage.id as dsid,
COUNT(*) as 'NFS'

FROM dwh_inventory.storage
JOIN dwh_inventory.nas_share
ON dwh_inventory.storage.id=dwh_inventory.nas_share.storageid
WHERE dwh_inventory.nas_share.protocol='NFS'
GROUP BY dwh_inventory.storage.id ) D ON D.dsid=A.storageid


LEFT JOIN

(
SELECT DISTINCT
dwh_inventory.storage.id as esid,
COUNT(*) as 'CIFS'

FROM dwh_inventory.storage
JOIN dwh_inventory.nas_share
ON dwh_inventory.storage.id=dwh_inventory.nas_share.storageid
WHERE dwh_inventory.nas_share.protocol='CIFS'
GROUP BY dwh_inventory.storage.id ) E ON E.esid=A.storageid

) Y ON Y.pstorageid=X.storageid



</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="storageid"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Family"/><mdProjectedItem name="Microcode Version"/><mdProjectedItem name="Data Center"/><mdProjectedItem name="IP"/><mdProjectedItem name="Node Name"/><mdProjectedItem name="Model"/><mdProjectedItem name="Serial Number"/><mdProjectedItem name="State"/><mdProjectedItem name="Raw (TB)"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="pstorageid"/><mdProjectedItem name="Protocol"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL4].[Storage Name]</expression></dataItem><dataItem name="storageid"><expression>[SQL4].[storageid]</expression></dataItem><dataItem name="Vendor"><expression>[SQL4].[Vendor]</expression></dataItem><dataItem name="Family"><expression>[SQL4].[Family]</expression></dataItem><dataItem name="Microcode Version"><expression>[SQL4].[Microcode Version]</expression></dataItem><dataItem name="Data Center"><expression>[SQL4].[Data Center]</expression></dataItem><dataItem name="IP"><expression>[SQL4].[IP]</expression></dataItem><dataItem name="Node Name"><expression>[SQL4].[Node Name]</expression></dataItem><dataItem name="Model"><expression>[SQL4].[Model]</expression></dataItem><dataItem name="Serial Number"><expression>[SQL4].[Serial Number]</expression></dataItem><dataItem name="State"><expression>[SQL4].[State]</expression></dataItem><dataItem name="Raw (TB)"><expression>[SQL4].[Raw (TB)]</expression></dataItem><dataItem name="Capacity (TB)"><expression>[SQL4].[Capacity (TB)]</expression></dataItem><dataItem name="pstorageid"><expression>[SQL4].[pstorageid]</expression></dataItem><dataItem name="Protocol" label="Protocols"><expression>[SQL4].[Protocol]</expression></dataItem></selection>
		</query></queries><reportVariables><reportVariable type="boolean" name="ShowHeader">
			<reportExpression>ReportOutput () contains 'HTML'</reportExpression>
			<variableValues>
				<variableValue value="1"/>
			</variableValues>
		</reportVariable></reportVariables></report>